{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pandas已经安装好，可以直接导入\n",
    "import pandas as pd\n",
    "#首先要创建一个query object对象\n",
    "#获取平台valuation表中，代码为601318的股票数据\n",
    "q = query(valuation).filter(valuation.code=='601318.XSHG')\n",
    "#把query object对象传入到get_fundamentals函数\n",
    "#并制定日期为2020年4月1日\n",
    "df = get_fundamentals(q, '2020-04-01')\n",
    "#查看返回的结果\n",
    "#df\n",
    "df.to_csv('out.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_bb = get_billboard_list(stock_list=None, end_date = '2022-05-23', count =1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>day</th>\n",
       "      <th>direction</th>\n",
       "      <th>rank</th>\n",
       "      <th>abnormal_code</th>\n",
       "      <th>abnormal_name</th>\n",
       "      <th>sales_depart_name</th>\n",
       "      <th>buy_value</th>\n",
       "      <th>buy_rate</th>\n",
       "      <th>sell_value</th>\n",
       "      <th>sell_rate</th>\n",
       "      <th>total_value</th>\n",
       "      <th>net_value</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>None</td>\n",
       "      <td>7.978229e+04</td>\n",
       "      <td>73.6896</td>\n",
       "      <td>5.958476e+04</td>\n",
       "      <td>55.0345</td>\n",
       "      <td>1.393670e+05</td>\n",
       "      <td>20197.53</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>中信证券股份有限公司杭州延安路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.384000e+03</td>\n",
       "      <td>5.8965</td>\n",
       "      <td>6.384000e+03</td>\n",
       "      <td>-6384.00</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>1</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>申万宏源证券有限公司青岛分公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.625440e+04</td>\n",
       "      <td>33.4858</td>\n",
       "      <td>3.625440e+04</td>\n",
       "      <td>-36254.40</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华泰证券股份有限公司西安文艺北路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.637500e+03</td>\n",
       "      <td>5.2070</td>\n",
       "      <td>5.637500e+03</td>\n",
       "      <td>-5637.50</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>申万宏源证券有限公司上海嘉定区塔城路证券营业部</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>5.5418</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>6000.00</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>信达证券股份有限公司上海虹口区海伦路证券营业部</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>8.8469</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>9578.40</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>中信建投证券股份有限公司天津育梁道证券营业部</td>\n",
       "      <td>1.403040e+04</td>\n",
       "      <td>12.9590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.403040e+04</td>\n",
       "      <td>14030.40</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>中信证券(山东)有限责任公司淄博柳泉路证券营业部</td>\n",
       "      <td>1.424069e+04</td>\n",
       "      <td>13.1532</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.424069e+04</td>\n",
       "      <td>14240.69</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华泰证券股份有限公司西安文艺北路证券营业部</td>\n",
       "      <td>3.593280e+04</td>\n",
       "      <td>33.1888</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.593280e+04</td>\n",
       "      <td>35932.80</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>国泰君安证券股份有限公司国际部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.082310e+03</td>\n",
       "      <td>5.6178</td>\n",
       "      <td>6.082310e+03</td>\n",
       "      <td>-6082.31</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>长江证券股份有限公司上海张杨路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.226550e+03</td>\n",
       "      <td>4.8274</td>\n",
       "      <td>5.226550e+03</td>\n",
       "      <td>-5226.55</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司深圳彩田路证券营业部</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>4.6957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>609.93</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中国银河证券股份有限公司台州银座北街证券营业部</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>5.0020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>649.71</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>平安证券股份有限公司平安证券总部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.441000e+02</td>\n",
       "      <td>2.6491</td>\n",
       "      <td>3.441000e+02</td>\n",
       "      <td>-344.10</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.719600e+02</td>\n",
       "      <td>2.0938</td>\n",
       "      <td>2.719600e+02</td>\n",
       "      <td>-271.96</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.247600e+02</td>\n",
       "      <td>1.7304</td>\n",
       "      <td>2.247600e+02</td>\n",
       "      <td>-224.76</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>2.4326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>315.98</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司南通人民中路证券营业部</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>2.3593</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>306.45</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>None</td>\n",
       "      <td>2.201160e+03</td>\n",
       "      <td>16.9462</td>\n",
       "      <td>1.368770e+03</td>\n",
       "      <td>10.5378</td>\n",
       "      <td>3.569930e+03</td>\n",
       "      <td>832.39</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>安信证券股份有限公司北京复兴门外大街证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.296100e+02</td>\n",
       "      <td>2.5376</td>\n",
       "      <td>3.296100e+02</td>\n",
       "      <td>-329.61</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中信证券股份有限公司杭州滨盛路证券营业部</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>2.4566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>319.09</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中信证券股份有限公司北京北三环中路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.983400e+02</td>\n",
       "      <td>1.5270</td>\n",
       "      <td>1.983400e+02</td>\n",
       "      <td>-198.34</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>None</td>\n",
       "      <td>1.761018e+04</td>\n",
       "      <td>6.8390</td>\n",
       "      <td>1.589931e+04</td>\n",
       "      <td>6.1745</td>\n",
       "      <td>3.350949e+04</td>\n",
       "      <td>1710.87</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国元证券股份有限公司上海中山北路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.593910e+03</td>\n",
       "      <td>1.3957</td>\n",
       "      <td>3.593910e+03</td>\n",
       "      <td>-3593.91</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>海通证券股份有限公司公司总部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.102760e+03</td>\n",
       "      <td>1.2050</td>\n",
       "      <td>3.102760e+03</td>\n",
       "      <td>-3102.76</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>湘财证券股份有限公司上海金沙江路证券营业部</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.728460e+03</td>\n",
       "      <td>1.0596</td>\n",
       "      <td>2.728460e+03</td>\n",
       "      <td>-2728.46</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>1.6009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>4122.36</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>1.5389</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>3962.52</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国盛证券有限责任公司湖北分公司</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>1.2912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>3324.86</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国元证券股份有限公司上海中山北路证券营业部</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>1.2524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>3224.82</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司上海环球金融中心证券营业部</td>\n",
       "      <td>3.579784e+07</td>\n",
       "      <td>1.4520</td>\n",
       "      <td>2.864210e+05</td>\n",
       "      <td>0.0116</td>\n",
       "      <td>3.608426e+07</td>\n",
       "      <td>35511417.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>1</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>深股通专用</td>\n",
       "      <td>6.132918e+07</td>\n",
       "      <td>2.4875</td>\n",
       "      <td>8.103213e+07</td>\n",
       "      <td>3.2867</td>\n",
       "      <td>1.423613e+08</td>\n",
       "      <td>-19702952.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司保定东风中路证券营业部</td>\n",
       "      <td>1.782606e+07</td>\n",
       "      <td>0.7230</td>\n",
       "      <td>4.902606e+07</td>\n",
       "      <td>1.9885</td>\n",
       "      <td>6.685211e+07</td>\n",
       "      <td>-31199998.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>平安证券股份有限公司杭州杭大路证券营业部</td>\n",
       "      <td>3.430425e+07</td>\n",
       "      <td>1.3914</td>\n",
       "      <td>3.451613e+07</td>\n",
       "      <td>1.4000</td>\n",
       "      <td>6.882038e+07</td>\n",
       "      <td>-211873.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>None</td>\n",
       "      <td>2.769094e+08</td>\n",
       "      <td>11.2315</td>\n",
       "      <td>2.511062e+08</td>\n",
       "      <td>10.1849</td>\n",
       "      <td>5.280157e+08</td>\n",
       "      <td>25803221.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>5</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>平安证券股份有限公司杭州杭大路证券营业部</td>\n",
       "      <td>3.430425e+07</td>\n",
       "      <td>1.3914</td>\n",
       "      <td>3.451613e+07</td>\n",
       "      <td>1.4000</td>\n",
       "      <td>6.882038e+07</td>\n",
       "      <td>-211873.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>财信证券股份有限公司杭州西湖国贸中心证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>3.854199e+07</td>\n",
       "      <td>1.5633</td>\n",
       "      <td>3.854199e+07</td>\n",
       "      <td>-38541994.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中国国际金融股份有限公司上海分公司</td>\n",
       "      <td>8.718729e+06</td>\n",
       "      <td>0.3536</td>\n",
       "      <td>4.194080e+07</td>\n",
       "      <td>1.7011</td>\n",
       "      <td>5.065953e+07</td>\n",
       "      <td>-33222072.00</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东亚前海证券有限责任公司湖北分公司</td>\n",
       "      <td>1.708946e+07</td>\n",
       "      <td>7.5176</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.708946e+07</td>\n",
       "      <td>17089464.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东亚前海证券有限责任公司广东分公司</td>\n",
       "      <td>1.057711e+07</td>\n",
       "      <td>4.6528</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.057711e+07</td>\n",
       "      <td>10577110.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>757</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>财信证券股份有限公司杭州西湖国贸中心证券营业部</td>\n",
       "      <td>1.052655e+07</td>\n",
       "      <td>4.6306</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.052655e+07</td>\n",
       "      <td>10526549.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>国盛证券有限责任公司沈阳广宜街证券营业部</td>\n",
       "      <td>9.692340e+06</td>\n",
       "      <td>4.2636</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>9.692340e+06</td>\n",
       "      <td>9692340.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>国金证券股份有限公司成都武成大街证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.132854e+07</td>\n",
       "      <td>9.3824</td>\n",
       "      <td>2.132854e+07</td>\n",
       "      <td>-21328535.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华鑫证券有限责任公司深圳益田路证券营业部</td>\n",
       "      <td>8.911706e+06</td>\n",
       "      <td>3.9202</td>\n",
       "      <td>4.050000e+03</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>8.915756e+06</td>\n",
       "      <td>8907656.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司南安成功街证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.604795e+06</td>\n",
       "      <td>2.4655</td>\n",
       "      <td>5.604795e+06</td>\n",
       "      <td>-5604795.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华福证券有限责任公司宁德分公司</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.245696e+06</td>\n",
       "      <td>2.3076</td>\n",
       "      <td>5.245696e+06</td>\n",
       "      <td>-5245696.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司宁波广福街证券营业部</td>\n",
       "      <td>1.103000e+03</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>2.787677e+06</td>\n",
       "      <td>1.2263</td>\n",
       "      <td>2.788780e+06</td>\n",
       "      <td>-2786574.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>兴业证券股份有限公司厦门湖里大道证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.347472e+06</td>\n",
       "      <td>1.0326</td>\n",
       "      <td>2.347472e+06</td>\n",
       "      <td>-2347472.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>000753.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>None</td>\n",
       "      <td>5.679827e+07</td>\n",
       "      <td>24.9854</td>\n",
       "      <td>3.731822e+07</td>\n",
       "      <td>16.4162</td>\n",
       "      <td>9.411650e+07</td>\n",
       "      <td>19480047.00</td>\n",
       "      <td>2.273260e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华泰证券股份有限公司上海共和新路证券营业部</td>\n",
       "      <td>6.385000e+05</td>\n",
       "      <td>3.6114</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>6.385000e+05</td>\n",
       "      <td>638500.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>山西证券股份有限公司南京汉中路证券营业部</td>\n",
       "      <td>8.456000e+05</td>\n",
       "      <td>4.7828</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.456000e+05</td>\n",
       "      <td>845600.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>湘财证券股份有限公司天津大沽北路证券营业部</td>\n",
       "      <td>9.184000e+05</td>\n",
       "      <td>5.1946</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>9.184000e+05</td>\n",
       "      <td>918400.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>东吴证券股份有限公司姜堰人民中路证券营业部</td>\n",
       "      <td>1.050000e+06</td>\n",
       "      <td>5.9389</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.050000e+06</td>\n",
       "      <td>1050000.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华泰证券股份有限公司上海武定路证券营业部</td>\n",
       "      <td>5.373930e+05</td>\n",
       "      <td>3.0396</td>\n",
       "      <td>1.391000e+05</td>\n",
       "      <td>0.7868</td>\n",
       "      <td>6.764930e+05</td>\n",
       "      <td>398293.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>1</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华龙证券股份有限公司银川正源北街证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.665966e+06</td>\n",
       "      <td>9.4229</td>\n",
       "      <td>1.665966e+06</td>\n",
       "      <td>-1665966.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>财通证券股份有限公司厦门分公司</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.956600e+05</td>\n",
       "      <td>5.0660</td>\n",
       "      <td>8.956600e+05</td>\n",
       "      <td>-895660.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>兴业证券股份有限公司福州工业路证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.995000e+05</td>\n",
       "      <td>3.3908</td>\n",
       "      <td>5.995000e+05</td>\n",
       "      <td>-599500.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>平安证券股份有限公司北京市分公司</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.824980e+05</td>\n",
       "      <td>2.7291</td>\n",
       "      <td>4.824980e+05</td>\n",
       "      <td>-482498.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>None</td>\n",
       "      <td>3.989893e+06</td>\n",
       "      <td>22.5673</td>\n",
       "      <td>4.292724e+06</td>\n",
       "      <td>24.2801</td>\n",
       "      <td>8.282617e+06</td>\n",
       "      <td>-302831.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>000585.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>SELL</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>安信证券股份有限公司北京远大路证券营业部</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.100000e+05</td>\n",
       "      <td>2.8846</td>\n",
       "      <td>5.100000e+05</td>\n",
       "      <td>-510000.00</td>\n",
       "      <td>1.767999e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>777 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            code         day      ...         net_value        amount\n",
       "0    900919.XSHG  2022-05-23      ...          20197.53  1.082680e+05\n",
       "1    900919.XSHG  2022-05-23      ...          -6384.00  1.082680e+05\n",
       "2    900919.XSHG  2022-05-23      ...         -36254.40  1.082680e+05\n",
       "3    900919.XSHG  2022-05-23      ...          -5637.50  1.082680e+05\n",
       "4    900919.XSHG  2022-05-23      ...           6000.00  1.082680e+05\n",
       "5    900919.XSHG  2022-05-23      ...           9578.40  1.082680e+05\n",
       "6    900919.XSHG  2022-05-23      ...          14030.40  1.082680e+05\n",
       "7    900919.XSHG  2022-05-23      ...          14240.69  1.082680e+05\n",
       "8    900919.XSHG  2022-05-23      ...          35932.80  1.082680e+05\n",
       "9    900919.XSHG  2022-05-23      ...          -6082.31  1.082680e+05\n",
       "10   900919.XSHG  2022-05-23      ...          -5226.55  1.082680e+05\n",
       "11   688325.XSHG  2022-05-23      ...            609.93  1.298913e+04\n",
       "12   688325.XSHG  2022-05-23      ...            649.71  1.298913e+04\n",
       "13   688325.XSHG  2022-05-23      ...           -344.10  1.298913e+04\n",
       "14   688325.XSHG  2022-05-23      ...           -271.96  1.298913e+04\n",
       "15   688325.XSHG  2022-05-23      ...           -224.76  1.298913e+04\n",
       "16   688325.XSHG  2022-05-23      ...            315.98  1.298913e+04\n",
       "17   688325.XSHG  2022-05-23      ...            306.45  1.298913e+04\n",
       "18   688325.XSHG  2022-05-23      ...            832.39  1.298913e+04\n",
       "19   688325.XSHG  2022-05-23      ...           -329.61  1.298913e+04\n",
       "20   688325.XSHG  2022-05-23      ...            319.09  1.298913e+04\n",
       "21   688325.XSHG  2022-05-23      ...           -198.34  1.298913e+04\n",
       "22   688317.XSHG  2022-05-23      ...           1710.87  2.574977e+05\n",
       "23   688317.XSHG  2022-05-23      ...          -3593.91  2.574977e+05\n",
       "24   688317.XSHG  2022-05-23      ...          -3102.76  2.574977e+05\n",
       "25   688317.XSHG  2022-05-23      ...          -2728.46  2.574977e+05\n",
       "26   688317.XSHG  2022-05-23      ...           4122.36  2.574977e+05\n",
       "27   688317.XSHG  2022-05-23      ...           3962.52  2.574977e+05\n",
       "28   688317.XSHG  2022-05-23      ...           3324.86  2.574977e+05\n",
       "29   688317.XSHG  2022-05-23      ...           3224.82  2.574977e+05\n",
       "..           ...         ...      ...               ...           ...\n",
       "747  000756.XSHE  2022-05-23      ...       35511417.00  2.465471e+09\n",
       "748  000756.XSHE  2022-05-23      ...      -19702952.00  2.465471e+09\n",
       "749  000756.XSHE  2022-05-23      ...      -31199998.00  2.465471e+09\n",
       "750  000756.XSHE  2022-05-23      ...        -211873.00  2.465471e+09\n",
       "751  000756.XSHE  2022-05-23      ...       25803221.00  2.465471e+09\n",
       "752  000756.XSHE  2022-05-23      ...        -211873.00  2.465471e+09\n",
       "753  000756.XSHE  2022-05-23      ...      -38541994.00  2.465471e+09\n",
       "754  000756.XSHE  2022-05-23      ...      -33222072.00  2.465471e+09\n",
       "755  000753.XSHE  2022-05-23      ...       17089464.00  2.273260e+08\n",
       "756  000753.XSHE  2022-05-23      ...       10577110.00  2.273260e+08\n",
       "757  000753.XSHE  2022-05-23      ...       10526549.00  2.273260e+08\n",
       "758  000753.XSHE  2022-05-23      ...        9692340.00  2.273260e+08\n",
       "759  000753.XSHE  2022-05-23      ...      -21328535.00  2.273260e+08\n",
       "760  000753.XSHE  2022-05-23      ...        8907656.00  2.273260e+08\n",
       "761  000753.XSHE  2022-05-23      ...       -5604795.00  2.273260e+08\n",
       "762  000753.XSHE  2022-05-23      ...       -5245696.00  2.273260e+08\n",
       "763  000753.XSHE  2022-05-23      ...       -2786574.00  2.273260e+08\n",
       "764  000753.XSHE  2022-05-23      ...       -2347472.00  2.273260e+08\n",
       "765  000753.XSHE  2022-05-23      ...       19480047.00  2.273260e+08\n",
       "766  000585.XSHE  2022-05-23      ...         638500.00  1.767999e+07\n",
       "767  000585.XSHE  2022-05-23      ...         845600.00  1.767999e+07\n",
       "768  000585.XSHE  2022-05-23      ...         918400.00  1.767999e+07\n",
       "769  000585.XSHE  2022-05-23      ...        1050000.00  1.767999e+07\n",
       "770  000585.XSHE  2022-05-23      ...         398293.00  1.767999e+07\n",
       "771  000585.XSHE  2022-05-23      ...       -1665966.00  1.767999e+07\n",
       "772  000585.XSHE  2022-05-23      ...        -895660.00  1.767999e+07\n",
       "773  000585.XSHE  2022-05-23      ...        -599500.00  1.767999e+07\n",
       "774  000585.XSHE  2022-05-23      ...        -482498.00  1.767999e+07\n",
       "775  000585.XSHE  2022-05-23      ...        -302831.00  1.767999e+07\n",
       "776  000585.XSHE  2022-05-23      ...        -510000.00  1.767999e+07\n",
       "\n",
       "[777 rows x 14 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_bb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "777"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_bb.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_pos = df_bb[(df_bb['net_value'] > 0) & (df_bb['rank'] > 0)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(351, 14)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pos.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>day</th>\n",
       "      <th>direction</th>\n",
       "      <th>rank</th>\n",
       "      <th>abnormal_code</th>\n",
       "      <th>abnormal_name</th>\n",
       "      <th>sales_depart_name</th>\n",
       "      <th>buy_value</th>\n",
       "      <th>buy_rate</th>\n",
       "      <th>sell_value</th>\n",
       "      <th>sell_rate</th>\n",
       "      <th>total_value</th>\n",
       "      <th>net_value</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司南通人民中路证券营业部</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>2.3593</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>2.4326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中信证券股份有限公司杭州滨盛路证券营业部</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>2.4566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中国银河证券股份有限公司北京中关村大街证券营业部</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>1.0882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>东方财富证券股份有限公司山南香曲东路证券营业部</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>1.3665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>海通证券股份有限公司贵阳富水北路证券营业部</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>1.3768</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>财通证券股份有限公司杭州上塘路证券营业部</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>1.4821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司深圳彩田路证券营业部</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>4.6957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中国银河证券股份有限公司台州银座北街证券营业部</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>5.0020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨团结路第二证券营业部</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>1.0626</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中信证券股份有限公司杭州文三路证券营业部</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>2.6255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国信证券股份有限公司广州东风中路证券营业部</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>1.4090</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司昌都两江大道证券营业部</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>1.7701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>2.2220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>1.2665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>1.4247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中国银河证券股份有限公司北京学院南路证券营业部</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>1.4455</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国盛证券有限责任公司湖北分公司</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>1.6624</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中国银河证券股份有限公司北京学院南路证券营业部</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>1.1556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国元证券股份有限公司上海中山北路证券营业部</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>1.2524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国盛证券有限责任公司湖北分公司</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>1.2912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>沪股通专用</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>4.3563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>1.5389</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>2.3450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>1.6009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>申万宏源证券有限公司上海嘉定区塔城路证券营业部</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>5.5418</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>国信证券股份有限公司深圳泰然九路证券营业部</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>6.8306</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>631</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>民生证券股份有限公司新密青屏大街证券营业部</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>6.8306</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>信达证券股份有限公司上海虹口区海伦路证券营业部</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>8.8469</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华龙证券股份有限公司兰州合水路证券营业部</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>10.2459</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106003</td>\n",
       "      <td>日价格振幅达到15%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>605</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>1.8180</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106003</td>\n",
       "      <td>日价格振幅达到15%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>639</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>6.764630e+07</td>\n",
       "      <td>1.3160</td>\n",
       "      <td>13036528.0</td>\n",
       "      <td>0.2536</td>\n",
       "      <td>8.068282e+07</td>\n",
       "      <td>5.460977e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>600038.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106002</td>\n",
       "      <td>跌幅偏离值达7%的证券</td>\n",
       "      <td>沪股通专用</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>5.1133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>1.092886e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司北京国贸证券营业部</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>0.9692</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>1.8957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>广发证券股份有限公司上海东方路证券营业部</td>\n",
       "      <td>6.909811e+07</td>\n",
       "      <td>2.6296</td>\n",
       "      <td>1241214.0</td>\n",
       "      <td>0.0472</td>\n",
       "      <td>7.033933e+07</td>\n",
       "      <td>6.785690e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司上海东方路证券营业部</td>\n",
       "      <td>7.042174e+07</td>\n",
       "      <td>1.3700</td>\n",
       "      <td>1971928.0</td>\n",
       "      <td>0.0384</td>\n",
       "      <td>7.239366e+07</td>\n",
       "      <td>6.844981e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司上海牡丹江路证券营业部</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>1.9932</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第一证券营业部</td>\n",
       "      <td>1.086605e+08</td>\n",
       "      <td>2.1139</td>\n",
       "      <td>36810732.0</td>\n",
       "      <td>0.7161</td>\n",
       "      <td>1.454712e+08</td>\n",
       "      <td>7.184975e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>8.301436e+07</td>\n",
       "      <td>3.3671</td>\n",
       "      <td>5438302.0</td>\n",
       "      <td>0.2206</td>\n",
       "      <td>8.845266e+07</td>\n",
       "      <td>7.757605e+07</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>1.2413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司广州番禺万达广场证券营业部</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>1.2534</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>1.4124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>3.5196</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>2.8075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>摩根大通证券（中国）有限公司上海银城中路证券营业部</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>2.9136</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>635</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>1.127024e+08</td>\n",
       "      <td>2.1925</td>\n",
       "      <td>2552106.0</td>\n",
       "      <td>0.0496</td>\n",
       "      <td>1.152545e+08</td>\n",
       "      <td>1.101503e+08</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司天津东丽开发区二纬路证券营业部</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>3.2137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.1184</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.1583</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>摩根大通证券（中国）有限公司上海银城中路证券营业部</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.3715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东方证券股份有限公司上海浦东新区源深路证券营业部</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>2.3064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司西安朱雀大街证券营业部</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>1.9540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>3.2671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>351 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            code         day      ...          net_value        amount\n",
       "17   688325.XSHG  2022-05-23      ...       3.064500e+02  1.298913e+04\n",
       "16   688325.XSHG  2022-05-23      ...       3.159800e+02  1.298913e+04\n",
       "20   688325.XSHG  2022-05-23      ...       3.190900e+02  1.298913e+04\n",
       "65   688276.XSHG  2022-05-23      ...       3.476400e+02  3.194646e+04\n",
       "56   688276.XSHG  2022-05-23      ...       4.365500e+02  3.194646e+04\n",
       "57   688276.XSHG  2022-05-23      ...       4.398400e+02  3.194646e+04\n",
       "64   688276.XSHG  2022-05-23      ...       4.734800e+02  3.194646e+04\n",
       "11   688325.XSHG  2022-05-23      ...       6.099300e+02  1.298913e+04\n",
       "12   688325.XSHG  2022-05-23      ...       6.497100e+02  1.298913e+04\n",
       "47   688289.XSHG  2022-05-23      ...       8.243400e+02  7.758028e+04\n",
       "58   688276.XSHG  2022-05-23      ...       8.387600e+02  3.194646e+04\n",
       "48   688289.XSHG  2022-05-23      ...       1.093070e+03  7.758028e+04\n",
       "49   688289.XSHG  2022-05-23      ...       1.373270e+03  7.758028e+04\n",
       "50   688289.XSHG  2022-05-23      ...       1.723810e+03  7.758028e+04\n",
       "31   688317.XSHG  2022-05-23      ...       2.140110e+03  1.689739e+05\n",
       "39   688317.XSHG  2022-05-23      ...       2.407300e+03  1.689739e+05\n",
       "37   688317.XSHG  2022-05-23      ...       2.442530e+03  1.689739e+05\n",
       "34   688317.XSHG  2022-05-23      ...       2.809050e+03  1.689739e+05\n",
       "30   688317.XSHG  2022-05-23      ...       2.975620e+03  2.574977e+05\n",
       "29   688317.XSHG  2022-05-23      ...       3.224820e+03  2.574977e+05\n",
       "28   688317.XSHG  2022-05-23      ...       3.324860e+03  2.574977e+05\n",
       "54   688289.XSHG  2022-05-23      ...       3.379650e+03  7.758028e+04\n",
       "27   688317.XSHG  2022-05-23      ...       3.962520e+03  2.574977e+05\n",
       "36   688317.XSHG  2022-05-23      ...       3.962520e+03  1.689739e+05\n",
       "26   688317.XSHG  2022-05-23      ...       4.122360e+03  2.574977e+05\n",
       "4    900919.XSHG  2022-05-23      ...       6.000000e+03  1.082680e+05\n",
       "630  002260.XSHE  2022-05-23      ...       8.000000e+03  1.171200e+05\n",
       "631  002260.XSHE  2022-05-23      ...       8.000000e+03  1.171200e+05\n",
       "5    900919.XSHG  2022-05-23      ...       9.578400e+03  1.082680e+05\n",
       "629  002260.XSHE  2022-05-23      ...       1.200000e+04  1.171200e+05\n",
       "..           ...         ...      ...                ...           ...\n",
       "598  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "605  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "619  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "431  003022.XSHE  2022-05-23      ...       4.777272e+07  2.627707e+09\n",
       "597  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "606  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "626  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "639  002183.XSHE  2022-05-23      ...       5.460977e+07  5.140286e+09\n",
       "324  600038.XSHG  2022-05-23      ...       5.588256e+07  1.092886e+09\n",
       "231  600418.XSHG  2022-05-23      ...       6.130713e+07  6.325239e+09\n",
       "254  600313.XSHG  2022-05-23      ...       6.703109e+07  3.535948e+09\n",
       "430  003022.XSHE  2022-05-23      ...       6.785690e+07  2.627707e+09\n",
       "638  002183.XSHE  2022-05-23      ...       6.844981e+07  5.140286e+09\n",
       "244  600313.XSHG  2022-05-23      ...       7.048008e+07  3.535948e+09\n",
       "636  002183.XSHE  2022-05-23      ...       7.184975e+07  5.140286e+09\n",
       "744  000756.XSHE  2022-05-23      ...       7.757605e+07  2.465471e+09\n",
       "240  600418.XSHG  2022-05-23      ...       7.851278e+07  6.325239e+09\n",
       "239  600418.XSHG  2022-05-23      ...       7.928141e+07  6.325239e+09\n",
       "238  600418.XSHG  2022-05-23      ...       8.933869e+07  6.325239e+09\n",
       "429  003022.XSHE  2022-05-23      ...       9.248364e+07  2.627707e+09\n",
       "243  600313.XSHG  2022-05-23      ...       9.927129e+07  3.535948e+09\n",
       "242  600313.XSHG  2022-05-23      ...       1.030242e+08  3.535948e+09\n",
       "635  002183.XSHE  2022-05-23      ...       1.101503e+08  5.140286e+09\n",
       "246  600313.XSHG  2022-05-23      ...       1.136344e+08  3.535948e+09\n",
       "255  600313.XSHG  2022-05-23      ...       1.165796e+08  1.042386e+10\n",
       "256  600313.XSHG  2022-05-23      ...       1.207365e+08  1.042386e+10\n",
       "257  600313.XSHG  2022-05-23      ...       1.429607e+08  1.042386e+10\n",
       "237  600418.XSHG  2022-05-23      ...       1.458852e+08  6.325239e+09\n",
       "258  600313.XSHG  2022-05-23      ...       2.036861e+08  1.042386e+10\n",
       "263  600313.XSHG  2022-05-23      ...       3.405610e+08  1.042386e+10\n",
       "\n",
       "[351 rows x 14 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 按多列排序\n",
    "df_sort = df_pos.sort_values([\"net_value\", \"total_value\"] , inplace=False, ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>day</th>\n",
       "      <th>direction</th>\n",
       "      <th>rank</th>\n",
       "      <th>abnormal_code</th>\n",
       "      <th>abnormal_name</th>\n",
       "      <th>sales_depart_name</th>\n",
       "      <th>buy_value</th>\n",
       "      <th>buy_rate</th>\n",
       "      <th>sell_value</th>\n",
       "      <th>sell_rate</th>\n",
       "      <th>total_value</th>\n",
       "      <th>net_value</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司南通人民中路证券营业部</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>2.3593</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>3.064500e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>2.4326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>3.159800e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中信证券股份有限公司杭州滨盛路证券营业部</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>2.4566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>3.190900e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中国银河证券股份有限公司北京中关村大街证券营业部</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>1.0882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>3.476400e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>东方财富证券股份有限公司山南香曲东路证券营业部</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>1.3665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>4.365500e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>海通证券股份有限公司贵阳富水北路证券营业部</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>1.3768</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>4.398400e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>财通证券股份有限公司杭州上塘路证券营业部</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>1.4821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>4.734800e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司深圳彩田路证券营业部</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>4.6957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>6.099300e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>688325.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中国银河证券股份有限公司台州银座北街证券营业部</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>5.0020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>6.497100e+02</td>\n",
       "      <td>1.298913e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨团结路第二证券营业部</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>1.0626</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>8.243400e+02</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>688276.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中信证券股份有限公司杭州文三路证券营业部</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>2.6255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>8.387600e+02</td>\n",
       "      <td>3.194646e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国信证券股份有限公司广州东风中路证券营业部</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>1.4090</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>1.093070e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司昌都两江大道证券营业部</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>1.7701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>1.373270e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>2.2220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>1.723810e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>1.2665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>2.140110e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>1.4247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>2.407300e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>中国银河证券股份有限公司北京学院南路证券营业部</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>1.4455</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>2.442530e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国盛证券有限责任公司湖北分公司</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>1.6624</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>2.809050e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>中国银河证券股份有限公司北京学院南路证券营业部</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>1.1556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>2.975620e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国元证券股份有限公司上海中山北路证券营业部</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>1.2524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>3.224820e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国盛证券有限责任公司湖北分公司</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>1.2912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>3.324860e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>688289.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>沪股通专用</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>4.3563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>3.379650e+03</td>\n",
       "      <td>7.758028e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>1.5389</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106019</td>\n",
       "      <td>有价格涨跌幅限制的日收盘价格涨幅达到15%的前五只证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>2.3450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>3.962520e+03</td>\n",
       "      <td>1.689739e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>688317.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106023</td>\n",
       "      <td>有价格涨跌幅限制的连续3个交易日内收盘价格涨幅偏离值累计达到30%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>1.6009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>4.122360e+03</td>\n",
       "      <td>2.574977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>申万宏源证券有限公司上海嘉定区塔城路证券营业部</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>5.5418</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>国信证券股份有限公司深圳泰然九路证券营业部</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>6.8306</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>631</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>民生证券股份有限公司新密青屏大街证券营业部</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>6.8306</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>900919.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>信达证券股份有限公司上海虹口区海伦路证券营业部</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>8.8469</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>9.578400e+03</td>\n",
       "      <td>1.082680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>002260.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106099</td>\n",
       "      <td>其它异常波动的证券</td>\n",
       "      <td>华龙证券股份有限公司兰州合水路证券营业部</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>10.2459</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>1.200000e+04</td>\n",
       "      <td>1.171200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106003</td>\n",
       "      <td>日价格振幅达到15%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>605</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.0187</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>4.548374e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>1.8180</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>4.777272e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106003</td>\n",
       "      <td>日价格振幅达到15%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>002431.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>东兴证券股份有限公司晋江和平路证券营业部</td>\n",
       "      <td>4.853006e+07</td>\n",
       "      <td>2.1539</td>\n",
       "      <td>174636.0</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>4.870469e+07</td>\n",
       "      <td>4.835542e+07</td>\n",
       "      <td>2.253160e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>639</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>6.764630e+07</td>\n",
       "      <td>1.3160</td>\n",
       "      <td>13036528.0</td>\n",
       "      <td>0.2536</td>\n",
       "      <td>8.068282e+07</td>\n",
       "      <td>5.460977e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>600038.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106002</td>\n",
       "      <td>跌幅偏离值达7%的证券</td>\n",
       "      <td>沪股通专用</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>5.1133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>5.588256e+07</td>\n",
       "      <td>1.092886e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司北京国贸证券营业部</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>0.9692</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>6.130713e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>1.8957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>6.703109e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>广发证券股份有限公司上海东方路证券营业部</td>\n",
       "      <td>6.909811e+07</td>\n",
       "      <td>2.6296</td>\n",
       "      <td>1241214.0</td>\n",
       "      <td>0.0472</td>\n",
       "      <td>7.033933e+07</td>\n",
       "      <td>6.785690e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司上海东方路证券营业部</td>\n",
       "      <td>7.042174e+07</td>\n",
       "      <td>1.3700</td>\n",
       "      <td>1971928.0</td>\n",
       "      <td>0.0384</td>\n",
       "      <td>7.239366e+07</td>\n",
       "      <td>6.844981e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司上海牡丹江路证券营业部</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>1.9932</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>7.048008e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第一证券营业部</td>\n",
       "      <td>1.086605e+08</td>\n",
       "      <td>2.1139</td>\n",
       "      <td>36810732.0</td>\n",
       "      <td>0.7161</td>\n",
       "      <td>1.454712e+08</td>\n",
       "      <td>7.184975e+07</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>000756.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>国泰君安证券股份有限公司上海分公司</td>\n",
       "      <td>8.301436e+07</td>\n",
       "      <td>3.3671</td>\n",
       "      <td>5438302.0</td>\n",
       "      <td>0.2206</td>\n",
       "      <td>8.845266e+07</td>\n",
       "      <td>7.757605e+07</td>\n",
       "      <td>2.465471e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>1.2413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>7.851278e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司广州番禺万达广场证券营业部</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>1.2534</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>7.928141e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>1.4124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>8.933869e+07</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>003022.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>机构专用</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>3.5196</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>9.248364e+07</td>\n",
       "      <td>2.627707e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>2.8075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>9.927129e+07</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>摩根大通证券（中国）有限公司上海银城中路证券营业部</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>2.9136</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>1.030242e+08</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>635</th>\n",
       "      <td>002183.XSHE</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106001</td>\n",
       "      <td>涨幅偏离值达7%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>1.127024e+08</td>\n",
       "      <td>2.1925</td>\n",
       "      <td>2552106.0</td>\n",
       "      <td>0.0496</td>\n",
       "      <td>1.152545e+08</td>\n",
       "      <td>1.101503e+08</td>\n",
       "      <td>5.140286e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106004</td>\n",
       "      <td>换手率达20%的证券</td>\n",
       "      <td>华泰证券股份有限公司天津东丽开发区二纬路证券营业部</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>3.2137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>1.136344e+08</td>\n",
       "      <td>3.535948e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司上海溧阳路证券营业部</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.1184</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.165796e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>4</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东方财富证券股份有限公司拉萨东环路第二证券营业部</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.1583</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.207365e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>3</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>摩根大通证券（中国）有限公司上海银城中路证券营业部</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.3715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.429607e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>600418.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>东方证券股份有限公司上海浦东新区源深路证券营业部</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>2.3064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>1.458852e+08</td>\n",
       "      <td>6.325239e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>2</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>中信证券股份有限公司西安朱雀大街证券营业部</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>1.9540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>2.036861e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>600313.XSHG</td>\n",
       "      <td>2022-05-23</td>\n",
       "      <td>BUY</td>\n",
       "      <td>1</td>\n",
       "      <td>106006</td>\n",
       "      <td>连续三个交易日内收盘价格涨幅偏离值累计达到20%的证券</td>\n",
       "      <td>华泰证券股份有限公司总部</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>3.2671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>3.405610e+08</td>\n",
       "      <td>1.042386e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>351 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            code         day      ...          net_value        amount\n",
       "17   688325.XSHG  2022-05-23      ...       3.064500e+02  1.298913e+04\n",
       "16   688325.XSHG  2022-05-23      ...       3.159800e+02  1.298913e+04\n",
       "20   688325.XSHG  2022-05-23      ...       3.190900e+02  1.298913e+04\n",
       "65   688276.XSHG  2022-05-23      ...       3.476400e+02  3.194646e+04\n",
       "56   688276.XSHG  2022-05-23      ...       4.365500e+02  3.194646e+04\n",
       "57   688276.XSHG  2022-05-23      ...       4.398400e+02  3.194646e+04\n",
       "64   688276.XSHG  2022-05-23      ...       4.734800e+02  3.194646e+04\n",
       "11   688325.XSHG  2022-05-23      ...       6.099300e+02  1.298913e+04\n",
       "12   688325.XSHG  2022-05-23      ...       6.497100e+02  1.298913e+04\n",
       "47   688289.XSHG  2022-05-23      ...       8.243400e+02  7.758028e+04\n",
       "58   688276.XSHG  2022-05-23      ...       8.387600e+02  3.194646e+04\n",
       "48   688289.XSHG  2022-05-23      ...       1.093070e+03  7.758028e+04\n",
       "49   688289.XSHG  2022-05-23      ...       1.373270e+03  7.758028e+04\n",
       "50   688289.XSHG  2022-05-23      ...       1.723810e+03  7.758028e+04\n",
       "31   688317.XSHG  2022-05-23      ...       2.140110e+03  1.689739e+05\n",
       "39   688317.XSHG  2022-05-23      ...       2.407300e+03  1.689739e+05\n",
       "37   688317.XSHG  2022-05-23      ...       2.442530e+03  1.689739e+05\n",
       "34   688317.XSHG  2022-05-23      ...       2.809050e+03  1.689739e+05\n",
       "30   688317.XSHG  2022-05-23      ...       2.975620e+03  2.574977e+05\n",
       "29   688317.XSHG  2022-05-23      ...       3.224820e+03  2.574977e+05\n",
       "28   688317.XSHG  2022-05-23      ...       3.324860e+03  2.574977e+05\n",
       "54   688289.XSHG  2022-05-23      ...       3.379650e+03  7.758028e+04\n",
       "27   688317.XSHG  2022-05-23      ...       3.962520e+03  2.574977e+05\n",
       "36   688317.XSHG  2022-05-23      ...       3.962520e+03  1.689739e+05\n",
       "26   688317.XSHG  2022-05-23      ...       4.122360e+03  2.574977e+05\n",
       "4    900919.XSHG  2022-05-23      ...       6.000000e+03  1.082680e+05\n",
       "630  002260.XSHE  2022-05-23      ...       8.000000e+03  1.171200e+05\n",
       "631  002260.XSHE  2022-05-23      ...       8.000000e+03  1.171200e+05\n",
       "5    900919.XSHG  2022-05-23      ...       9.578400e+03  1.082680e+05\n",
       "629  002260.XSHE  2022-05-23      ...       1.200000e+04  1.171200e+05\n",
       "..           ...         ...      ...                ...           ...\n",
       "598  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "605  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "619  002431.XSHE  2022-05-23      ...       4.548374e+07  2.253160e+09\n",
       "431  003022.XSHE  2022-05-23      ...       4.777272e+07  2.627707e+09\n",
       "597  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "606  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "626  002431.XSHE  2022-05-23      ...       4.835542e+07  2.253160e+09\n",
       "639  002183.XSHE  2022-05-23      ...       5.460977e+07  5.140286e+09\n",
       "324  600038.XSHG  2022-05-23      ...       5.588256e+07  1.092886e+09\n",
       "231  600418.XSHG  2022-05-23      ...       6.130713e+07  6.325239e+09\n",
       "254  600313.XSHG  2022-05-23      ...       6.703109e+07  3.535948e+09\n",
       "430  003022.XSHE  2022-05-23      ...       6.785690e+07  2.627707e+09\n",
       "638  002183.XSHE  2022-05-23      ...       6.844981e+07  5.140286e+09\n",
       "244  600313.XSHG  2022-05-23      ...       7.048008e+07  3.535948e+09\n",
       "636  002183.XSHE  2022-05-23      ...       7.184975e+07  5.140286e+09\n",
       "744  000756.XSHE  2022-05-23      ...       7.757605e+07  2.465471e+09\n",
       "240  600418.XSHG  2022-05-23      ...       7.851278e+07  6.325239e+09\n",
       "239  600418.XSHG  2022-05-23      ...       7.928141e+07  6.325239e+09\n",
       "238  600418.XSHG  2022-05-23      ...       8.933869e+07  6.325239e+09\n",
       "429  003022.XSHE  2022-05-23      ...       9.248364e+07  2.627707e+09\n",
       "243  600313.XSHG  2022-05-23      ...       9.927129e+07  3.535948e+09\n",
       "242  600313.XSHG  2022-05-23      ...       1.030242e+08  3.535948e+09\n",
       "635  002183.XSHE  2022-05-23      ...       1.101503e+08  5.140286e+09\n",
       "246  600313.XSHG  2022-05-23      ...       1.136344e+08  3.535948e+09\n",
       "255  600313.XSHG  2022-05-23      ...       1.165796e+08  1.042386e+10\n",
       "256  600313.XSHG  2022-05-23      ...       1.207365e+08  1.042386e+10\n",
       "257  600313.XSHG  2022-05-23      ...       1.429607e+08  1.042386e+10\n",
       "237  600418.XSHG  2022-05-23      ...       1.458852e+08  6.325239e+09\n",
       "258  600313.XSHG  2022-05-23      ...       2.036861e+08  1.042386e+10\n",
       "263  600313.XSHG  2022-05-23      ...       3.405610e+08  1.042386e+10\n",
       "\n",
       "[351 rows x 14 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sort"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "688325.XSHG\n",
      "688325.XSHG\n",
      "688325.XSHG\n",
      "688276.XSHG\n"
     ]
    }
   ],
   "source": [
    "cnt = 0\n",
    "for item in df_sort['code']:\n",
    "    cnt += 1\n",
    "    if cnt >= 5:\n",
    "        break\n",
    "    print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": false,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "MarkDown菜单",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}